In Replenishment Parameter F/M, the Alert on Non-Replenished Items with Hits parameter in the Alerts category was enhanced to include a new field, Within Last # Days. When alerting on non-replenished items with hits, the user enters the number of hits within the previous number of months that a non-replenished item must achieve in order to generate an alert. The new field, Within Last # Days, allows the user to further clarify that the most recent hit must have been within the given number of days in order for an alert to be raised.
A new parameter, Threshold Maximum Line Point, was added to the Replenishment Parameters F/M program. It is in the Line Point Category and is used to set a maximum Line Point. The calculation and show math features were updated to use this new feature.
The Rebuild Inventory Sort Files (ICU990) was removed from FACTS 9.0.0. The new background process, Rebuild Sort Files (S2), now contains the rebuild process for IC sort files.
Use the new Import/Export Manual Costs and List Prices (ICU870) program to work with manual costs and list prices for various items, and with either suggested cost/price records or vendor/item records. It utilizes Microsoft Excel and will either export records to a spreadsheet or import records from the spreadsheet. Note that the first row of the spreadsheet must be specific column headers in order to be recognized. These case-sensitive column headers are identified in the instruction text on the screen when running the Import/Export program.
For vendor/item records:
When exporting vendor/item records, you must select a Vendor and Warehouse to export for, and you can select to export existing vendor/item records or all the given vendor's items in the selected warehouse.
The export of vendor/item records will create a spreadsheet that can be updated an imported to change and/or create new vendor/item records.
When importing vendor/item costs, if a vendor/item record doesn't exist for the selected vendor and warehouse, it will be created. This provides a simple way to create vendor items records. In addition to updating the manual cost, it can also be used to update the vendor's item number itself, providing a simple way to initially populate the vendor/items. For example, to copy all vendor/items from one warehouse to another, export the existing warehouse, then delete the entire Warehouse column, then import the spreadsheet into the new warehouse.
If the spreadsheet has a vendor column on it and vendor numbers are entered, the import will only import row where the vendor numbers match what was entered on the import screen. If the vendor column is not present on the spreadsheet, all rows will be imported. This same rule applies to the warehouse column.
To update costs, both a cost and a cost UM column must be present, and the cost UM must match the item's costing UM or the line will be skipped.
For suggested cost/price records:
When exporting suggested records, only existing suggested manual costs and list prices will be exported, and it cannot be limited in any other way. Of course, you can delete any unwanted lines from the spreadsheet after it's created.
Importing suggested manual costs and list prices will either create new suggested records or change existing records. You can import the following information:
The spreadsheet used does not have to be one that was created by the Export process. There are only a few requirements of the spreadsheet, including:
A spreadsheet can be used and reused as often as desired.
Please note that Microsoft Excel may misinterpret some characters at the beginning of an entry. If you have any such data, be sure all columns used for that data are formatted properly to prevent Excel from altering your data.
Also note that this program is not allowed to be run via Job Stream.
The Item Changer program has been modified and is now based on metadata instead of the hard-coded list of places the item number is found.
These changes were implemented in the FACTS 9.0 system.
DOTYPE – Now contains two options for whether the type is eligible for Mass Change and/or Mass Delete. The Mass Change and/or Mass Delete options should not be turned on unless all of the occurrences of that data type are properly identified in DOFILB and/or hard-coded into SMC999.
If Mass Delete is enabled, the Delete record option will automatically check whether the current record can be deleted.
The Edit FM screen for File Maintenance Setup (SME0202) - SMFMFM, now has an entry for data Class on the General tab. If that is filled in, the FM will automatically provide these additional options.
DOFILB - Each record now has two new options:
• whether that field should be changed when the changer is run
• the appropriate action to take when the deleter is run. The options are: N-N/A, P-Prevent Delete, D-Delete This Record, and I-Ignore.
Note that some occurrences of a data type can't be accurately defined in DOFILB (e.g. Notes files), and these must be defined in SMC999;get_file_usage.
A new menu option, File/Show Where Used, will present a list of all places the current record is in use in FACTS. Only select F/Ms have this option. All F/Ms now have a File menu with an Exit selection.
New functionality, the ability to perform mass item deletion, was introduced in Inventory Control in FACTS 9.0.0. Two new programs were added to the Infrequent File Maintenance menu: Multiple Item Deletion Entry (ICE110), allows the user to pre-enter the items they want to delete and to enter the appropriate Sales Analysis item to transfer historic information to and Multiple Item Deletion (ICU110), which actually checks the items and/or deletes them.
Use this program to specify the items to delete and enter the appropriate Sales Analysis item to transfer historic information to. Use the Selection button to add or remove a range of items from the to-be-deleted list. The items are not actually be deleted or checked for deletion in this program. The Multiple Item Deletion (ICU110) program is used in conjunction with this program to check and then delete the items you have entered here. When you run Multiple Item Deletion, if the item is not able to be deleted for any reason, you can return to this program and the issues will be displayed here so you can resolve them and then re-run Multiple Item Deletion (ICU110) for deletion.
Use Multiple Item Deletion to check the items entered in Multiple Item Deletion Entry (ICE110) and/or delete them. When Update Type is set to "Check Only", each item in the to-be-deleted list (created in Multiple Item Deletion Entry) will be checked, and any issues will be made available to the Multiple Item Deletion Entry program. When Update Type is set to "Check/Update", the check is run first, then all of the items which have no reported issues are deleted and removed from the to-be-deleted list. All items on the to-be-deleted list which have issues will be skipped and left on the to-be-deleted list for review in Multiple Item Deletion Entry (ICE110).